package org.example.news.mapper;

import org.apache.ibatis.annotations.*;
import org.example.news.pojo.Article;

import java.util.List;

@Mapper
public interface ArticleMapper {


    //新增文章
    @Insert("insert  into  article (title,content,cover_img,state,category_id,create_user,create_time,update_time)" +
   "values(#{title},#{content},#{coverImg},#{state},#{categoryId},#{createUser},#{createTime},#{updateTime})" )
    void add(Article article);

    //条件分页
    List<Article> list(@Param("userId") Integer userId, @Param("categoryId")  Integer categoryId, @Param("state") String state);


    //获取文章详情
    @Select("select * from article where id=#{id}")
    Article findById(Integer id);

    //删除文章
    @Delete("delete  from article where id=#{id}")
    void deleteById(Integer id);


    //更新文章
    @Update("update  article set title=#{title},content=#{content},cover_img=#{coverImg} ,state=#{state},article.category_id=#{categoryId} ,update_time=#{updateTime} where id=#{id}")
    void update(Article article);
}
